Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | |
ReasonCode (FK) | A unique retailer defined reason code for an action that is taken (or not taken) at a Workstation. e.g. Return reason codes - Past Use By Date, Defective Merchandise, etc. POSNoSale reason Codes - Customer Change Query | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
ExceptionalTaxRuleFlag | A flag denoting that a special TaxGroupRule has been invoked rather than the normal one. | FL_TX_RU_EXC | Flag | integer | |
TaxIncludedInPricesFlag | A flag denoting that all applicable taxes are included in the prices for this line item, and that therefore this SaleReturnTaxLineItem is merely a summary of those taxes, | FL_TX_INCL_PR | Flag | integer | |
TaxAtSourceFlag | A flag denoting that the goods being sold and shipped have been taxed according to the TaxAuthorityShippingRule. | FL_TX_SRC | Flag | integer | |
TaxablePercent | The percentage of the taxable amount that is liable for tax. Usually this is 100% but where an aggregate item contains taxed and non-taxed goods this value may be less than 100%. | PE_TXBLE | Percent | decimal(7,4) | |
TaxableAmount | The monetary value of the transaction for which tax is being calculated. | MO_TXBL | Money | decimal(16,5) | |
TaxPercent | The percentage of the taxable amount that should is tax. Derived by applying the appropriate TaxGroupRule and TaxRateRule. | PE_TXBL | Percent | decimal(7,4) | |
TaxAmount | The monetary amount of sales Tax calculated by applying the appropriate TaxGroupRule and TaxRateRule. | MO_TX | Money | decimal(16,5) | |
TaxGroupRuleID (FK) | System assigned unique identifier for the TaxGroupRule. | ID_RU_TX_GRP | Identity | integer | TaxGroupRule(RU_TX_GP) |